Both "effective in" and "effective at" can be correct, depending on the context. Use "effective in" when referring to a specific area or situation where something is effective. Use "effective at" when referring to a specific task or action at which something is effective.